/*
 *  mini-SaaS
 *  Application for developing Software as a Service (SaaS) 
 *  Copyright (c) 2011 Anand Sudhakaran, Bryce Holton, Chao Zhang
 *  ASU
 *
 *  This file is part of mini-SaaS.
 *
 *  mini-SaaS is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  mini-SaaS is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.

 *  You should have received a copy of the GNU General Public License
 *  along with mini-SaaS; if not, see <http://www.gnu.org/licenses/>. 
 *
 */

package loginbean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;

public class AddToCartService 
{
	private static Vector<String> queryDataBase(String query)
	{
		Vector<String> results = new Vector<String>();
		try
		{
			DBManager db = new DBManager();
			Connection conn = db.getDatabaseConnection();
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(query);
			while(rs.next())
			{
				results.addElement(rs.getString(1));
			}
			conn.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return results;
	}
	private static void insertIntoDataBase(String query)
	{
		try
		{
			DBManager db = new DBManager();
			Connection conn = db.getDatabaseConnection();
			Statement st = conn.createStatement();
			st.execute(query);
			conn.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void addProductToShoppingCart(int tenantId, String productName, int custId)
	{
		String query = "select value from datatable,objecttable,fieldtable where datatable.fieldid=fieldtable.fieldid"
				+" and fieldtable.objectid=objecttable.objectid and objectname='Cart' and ";
	}
}
